EDS 213 Discussion 1
Spring Quarter
Discussion section overview
The goal of our weekly discussion sections will be to answer an analytical question of your choosing using a database. You will create this database yourself, and then use it to answer your question.
Schedule
| Week | Objective |
|---|---|
| 1 | Select a dataset and understand the relationships among the different tables to define a schema. You can pick a dataset(s) from this list, or find your own! |
| 2 | Clean the data. |
| 3 | Ingest the data into a database and explore your newly created database. |
| 4 | After cleaning your data and having it in a database, come up with an analytical question to answer with your database.Develop the SQL query/ queries to answer this question. |
| 5 | Write some R or Python code to create some data visualization/ analysis with your database. |
| 6 | Document your work. |
| 7 | Database showcase! |